Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# About Static Data Dictionary Views

Data dictionary tables are not directly accessible, but you can access information in them through data dictionary views. To list the data dictionary views available to you, query the view `DICTIONARY`.

Many data dictionary tables have three corresponding views:

- An `ALL_` view displays all the information accessible to the current user, including information from the current user's schema as well as information from objects in other schemas, if the current user has access to those objects by way of grants of privileges or roles.

- A `DBA_` view displays all relevant information in the entire database. `DBA_` views are intended only for administrators. They can be accessed only by users with the `SELECT ANY TABLE` privilege. This privilege is assigned to the `DBA` role when the system is initially installed.

- A `USER_` view displays all the information from the schema of the current user. No special privileges are required to query these views.

The columns of the `ALL_`, `DBA_`, and `USER_` views corresponding to a single data dictionary table are usually nearly identical. Therefore, these views are described in full only once in this chapter, at their first occurrence alphabetically, and are listed without full descriptions at their other occurrences.

## Oracle Replication Views

A number of data dictionary views are relevant only if you are using Oracle Replication. Table 2-1 lists these views.

Table 2-1 Oracle Replication Data Dictionary Views

ALL_ Views | DBA_ Views | USER_ Views
--- | --- | ---
`ALL_REPCAT` | `DBA_REPCAT` | `USER_REPCAT`
| `DBA_REPCAT_EXCEPTIONS` |
`ALL_REPCAT_REFRESH_TEMPLATES` | `DBA_REPCAT_REFRESH_TEMPLATES` | `USER_REPCAT_REFRESH_TEMPLATES`
`ALL_REPCAT_TEMPLATE_OBJECTS` | `DBA_REPCAT_TEMPLATE_OBJECTS` | `USER_REPCAT_TEMPLATE_OBJECTS`
`ALL_REPCAT_TEMPLATE_PARMS` | `DBA_REPCAT_TEMPLATE_PARMS` | `USER_REPCAT_TEMPLATE_PARMS`
`ALL_REPCAT_TEMPLATE_SITES` | `DBA_REPCAT_TEMPLATE_SITES` | `USER_REPCAT_TEMPLATE_SITES`
`ALL_REPCAT_USER_AUTHORIZATIONS` | `DBA_REPCAT_USER_AUTHORIZATIONS` | `USER_REPCAT_USER_AUTHORIZATIONS`
`ALL_REPCAT_USER_PARM_VALUES` | `DBA_REPCAT_USER_PARM_VALUES` | `USER_REPCAT_USER_PARM_VALUES`
`ALL_REPCATLOG` | `DBA_REPCATLOG` | `USER_REPCATLOG`
`ALL_REPCOLUMN` | `DBA_REPCOLUMN` | `USER_REPCOLUMN`
`ALL_REPCOLUMN_GROUP` | `DBA_REPCOLUMN_GROUP` | `USER_REPCOLUMN_GROUP`
`ALL_REPCONFLICT` | `DBA_REPCONFLICT` | `USER_REPCONFLICT`
`ALL_REPDDL` | `DBA_REPDDL` | `USER_REPDDL`
| `DBA_REPEXTENSIONS` |
`ALL_REPFLAVOR_COLUMNS` | `DBA_REPFLAVOR_COLUMNS` | `USER_REPFLAVOR_COLUMNS`
`ALL_REPFLAVOR_OBJECTS` | `DBA_REPFLAVOR_OBJECTS` | `USER_REPFLAVOR_OBJECTS`
`ALL_REPFLAVORS` | `DBA_REPFLAVORS` | `USER_REPFLAVORS`
`ALL_REPGENERATED` | `DBA_REPGENERATED` | `USER_REPGENERATED`
`ALL_REPGENOBJECTS` | `DBA_REPGENOBJECTS` | `USER_REPGENOBJECTS`
`ALL_REPGROUP` | `DBA_REPGROUP` | `USER_REPGROUP`
`ALL_REPGROUP_PRIVILEGES` | `DBA_REPGROUP_PRIVILEGES` | `USER_REPGROUP_PRIVILEGES`
`ALL_REPGROUPED_COLUMN` | `DBA_REPGROUPED_COLUMN` | `USER_REPGROUPED_COLUMN`
`ALL_REPKEY_COLUMNS` | `DBA_REPKEY_COLUMNS` | `USER_REPKEY_COLUMNS`
`ALL_REPOBJECT` | `DBA_REPOBJECT` | `USER_REPOBJECT`
`ALL_REPPARAMETER_COLUMN` | `DBA_REPPARAMETER_COLUMN` | `USER_REPPARAMETER_COLUMN`
`ALL_REPPRIORITY` | `DBA_REPPRIORITY` | `USER_REPPRIORITY`
`ALL_REPPRIORITY_GROUP` | `DBA_REPPRIORITY_GROUP` | `USER_REPPRIORITY_GROUP`
`ALL_REPPROP` | `DBA_REPPROP` | `USER_REPPROP`
`ALL_REPRESOL_STATS_CONTROL` | `DBA_REPRESOL_STATS_CONTROL` | `USER_REPRESOL_STATS_CONTROL`
`ALL_REPRESOLUTION` | `DBA_REPRESOLUTION` | `USER_REPRESOLUTION`
`ALL_REPRESOLUTION_METHOD` | `DBA_REPRESOLUTION_METHOD` | `USER_REPRESOLUTION_METHOD`
`ALL_REPRESOLUTION_STATISTICS` | `DBA_REPRESOLUTION_STATISTICS` | `USER_REPRESOLUTION_STATISTICS`
`ALL_REPSCHEMA` | `DBA_REPSCHEMA` | `USER_REPSCHEMA`
`ALL_REPSITES` | `DBA_REPSITES` | `USER_REPSITES`
| `DBA_REPSITES_NEW` |

The following are additional Oracle Replication data dictionary views:

`DEFCALL`
`DEFCALLDEST`
`DEFDEFAULTDEST`
`DEFERRCOUNT`
`DEFERROR`
`DEFLOB`
`DEFPROPAGATOR`
`DEFSCHEDULE`
`DEFTRAN`
`DEFTRANDEST`

See Also: Oracle Database Advanced Replication Management API Reference for information about these views

## Oracle Workspace Manager Views

A number of data dictionary views are relevant only if you are using Oracle Workspace Manager. Table 2-2 lists these views.

Table 2-2 Oracle Workspace Manager Data Dictionary Views

ALL_ Views | DBA_ Views | USER_ Views
--- | --- | ---
`ALL_VERSION_HVIEW` |  |
`ALL_WM_LOCKED_TABLES` |  | `USER_WM_LOCKED_TABLES`
`ALL_WM_MODIFIED_TABLES` |  | `USER_WM_MODIFIED_TABLES`
|  | `USER_WM_PRIVS`
`ALL_WM_RIC_INFO` |  | `USER_WM_RIC_INFO`
`ALL_WM_TAB_TRIGGERS` |  | `USER_WM_TAB_TRIGGERS`
`ALL_WM_VERSIONED_TABLES` |  | `USER_WM_VERSIONED_TABLES`
`ALL_WM_VT_ERRORS` |  | `USER_WM_VT_ERRORS`
`ALL_WORKSPACE_PRIVS` |  | `USER_WORKSPACE_PRIVS`
`ALL_WORKSPACE_SAVEPOINTS` |  | `USER_WORKSPACE_SAVEPOINTS`
| `DBA_WORKSPACE_SESSIONS` |
`ALL_WORKSPACES` | `DBA_WORKSPACES` | `USER_WORKSPACES`

The following are additional Oracle Workspace Manager data dictionary views:

`ROLE_WM_PRIVS`
`WM_INSTALLATION`
`WM_REPLICATION_INFO`

See Also: Oracle Database Application Developer's Guide - Workspace Manager for information about these views

## Recovery Catalog Views

The following data dictionary views are only available after you create an optional recovery catalog (which contains schemas containing information about backups) for use with Recovery Manager:

`RC_ARCHIVED_LOG`
`RC_BACKUP_CONTROLFILE`
`RC_BACKUP_CORRUPTION`
`RC_BACKUP_DATAFILE`
`RC_BACKUP_FILES`
`RC_BACKUP_PIECE`
`RC_BACKUP_REDOLOG`
`RC_BACKUP_SET`
`RC_BACKUP_SPFILE`
`RC_CHECKPOINT`
`RC_CONTROLFILE_COPY`
`RC_COPY_CORRUPTION`
`RC_DATABASE`
`RC_DATABASE_BLOCK_CORRUPTION`
`RC_DATABASE_INCARNATION`
`RC_DATAFILE`
`RC_DATAFILE_COPY`
`RC_LOG_HISTORY`
`RC_OFFLINE_RANGE`
`RC_PROXY_CONTROLFILE`
`RC_PROXY_DATAFILE`
`RC_REDO_LOG`
`RC_REDO_THREAD`
`RC_RESYNC`
`RC_RMAN_BACKUP_JOB_DETAILS`
`RC_RMAN_BACKUP_SUBJOB_DETAILS`
`RC_RMAN_CONFIGURATION`
`RC_RMAN_OUTPUT`
`RC_RMAN_STATUS`
`RC_STORED_SCRIPT`
`RC_STORED_SCRIPT_LINE`
`RC_TABLESPACE`
`RC_TEMPFILE`

See Also: Oracle Database Backup and Recovery Reference for information about these views